[dbo].[BAEImisNameSecurityGroupsAdd]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisNameSecurityGroupsAdd

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@Id	varchar(10)	10
@securityGroup	varchar(30)	30

SQL Script

create procedure [dbo].[BAEImisNameSecurityGroupsAdd] @Id varchar(10),
     @securityGroup varchar(30) as
INSERT INTO Name_Security_Groups([ID], SECURITY_GROUP)
    VALUES(@Id, @securityGroup)

    SELECT @@Identity AS 'Id'

GO

Uses

[dbo].[Name_Security_Groups]
dbo